Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# PAGESIZE

The PAGESIZE option specifies the size of a page of output. The value of PAGESIZE is the number of output lines to be produced on each page. PAGESIZE is usually used in the initialization section of report programs. The PAGESIZE option is meaningful only when PAGING is set to `YES` and only for output from statements such as REPORT and LISTNAMES. PAGESIZE also controls the LINESLEFT option. When PAGESIZE is changed, Oracle OLAP adjusts LINESLEFT accordingly.

See also: PAGE, PAGING, LINESLEFT

Data type

INTEGER

Syntax

PAGESIZE = n

Arguments

n

  An `INTEGER` expression that specifies the number of output lines on a page; n includes the top and bottom margins (controlled by the TMARGIN and BMARGIN options). The default is 66 lines, which is suitable for printing report output on 8 1/2" by 11" paper.

Notes

Usable Output Lines with Standard Heading and Default Settings

When you use the standard heading and the default settings for the PAGESIZE, TMARGIN, and BMARGIN options, the total number of usable output lines is 61.

    Output Lines
    Lines from PAGESIZE                     66
    Lines for TMARGIN                      - 2
    Lines for the standard heading         - 2
    Lines for BMARGIN                      - 1
    Lines available for output              61

Eliminating Headings and Page Breaks

You can produce pages with no headings by using the statement `PAGEPRG='NONE'` or suppress page breaks entirely by using the statement `PAGING = NO`.

Setting PAGESIZE for a File

To set PAGESIZE for a file, first make the file your current outfile by specifying its name in an OUTFILE statement, then set PAGESIZE to the desired value. The new value remains in effect until you reset it or until you use an OUTFILE statement to direct output to a different outfile. When you direct output to a different outfile, PAGESIZE returns to its default value of `66` for the file.

When you set PAGESIZE for the default outfile, the new value remains in effect until you reset it, regardless of intervening OUTFILE commands that send output to a file. That is, the value of PAGESIZE is automatically saved for the default outfile.

Examples

Example 19-24 Printing on Legal Paper

In this example, you want to produce a report that you will print on legal-size paper (8 1/2" by 14"). Include the following statement in the initialization section of your report program.

    PAGESIZE = 84